---------------- loai tai khoan-----------------
---------- thong tin
if exists (select name from sysobjects where name like 'Proc_LoaiTaiKhoan_GetById')
	drop procedure Proc_LoaiTaiKhoan_GetById
go

create PROC Proc_LoaiTaiKhoan_GetById (@maLoaiTK int )
as
	select * from LoaiTaiKhoan
	where MaLoaiTK = @maLoaiTK
go

Exec Proc_LoaiTaiKhoan_GetById 1
go

---------------- -----------------------------
-------- thongtin thong qua maloaiky han----------------
---------- thong tin khach hang
if exists (select name from sysobjects where name like 'Proc_LoaiTaiKhoan_GetByMaLoaiKyHan')
	drop procedure Proc_LoaiTaiKhoan_GetByMaLoaiKyHan
go

create PROC Proc_LoaiTaiKhoan_GetByMaLoaiKyHan (@maLoaiKyHan int )
as
	select * from LoaiTaiKhoan
	where MaLoaiKyHan = @maLoaiKyHan
go

Exec Proc_LoaiTaiKhoan_GetByMaLoaiKyHan 1
go

